The following code example demonstrates an incorrect parameter ordering 下面的代碼示例演示的參數(shù)排序是不正確的。
Failure to specify the correct types is a common error that can result in unexpected behavior because the function called is executed with incorrect parameter values 指定正確類型失敗是常見錯誤,它可能導致意外行為,因為調(diào)用的函數(shù)是使用不正確的參數(shù)值執(zhí)行的。
To find the problem , step through the code or of using just - in - time debugging until you find where the failure occurs , and then determine the incorrect parameters or code 若要找到問題,請逐句通過代碼(或者使用實時調(diào)試) ,直到找到發(fā)生失敗的位置,然后確定不正確的參數(shù)或代碼。
In sql server 2000 , when a remote stored procedure does not run successfully because of compile - time errors such an incorrect parameter binding , the return value status is set to 0 在sql server 2000中,當遠程存儲過程由于編譯時錯誤(如參數(shù)綁定不正確)而不能成功運行時,返回值/狀態(tài)會設為0 。